/****** Object:  View [dbo].[Alphabetical list of products]    Script Date: 06/12/2011 01:42:52 ******/
DROP VIEW [dbo].[Alphabetical list of products]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[Alphabetical list of products] AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))
GO
